/*
   Copyright (C) 2002 MySQL AB

      This program is free software; you can redistribute it and/or modify
      it under the terms of the GNU General Public License as published by
      the Free Software Foundation; either version 2 of the License, or
      (at your option) any later version.

      This program is distributed in the hope that it will be useful,
      but WITHOUT ANY WARRANTY; without even the implied warranty of
      MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
      GNU General Public License for more details.

      You should have received a copy of the GNU General Public License
      along with this program; if not, write to the Free Software
      Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

 */
package com.mysql.jdbc;

import java.sql.Time;
import java.sql.Timestamp;
import java.util.Calendar;
import java.util.Collections;
import java.util.HashMap;
import java.util.Map;
import java.util.TimeZone;


/**
 * Timezone conversion routines
 *
 * @author Mark Matthews
 */
public class TimeUtil {
    static final TimeZone GMT_TIMEZONE = TimeZone.getTimeZone("GMT");
    static final Map TIMEZONE_MAPPINGS;
    static final Map ABBREVIATED_TIMEZONES;

    static {
        HashMap tempMap = new HashMap();

        //
        // Windows Mappings
        //
        tempMap.put("Romance", "Europe/Paris");
        tempMap.put("Romance Standard Time", "Europe/Paris");
        tempMap.put("Warsaw", "Europe/Warsaw");
        tempMap.put("Central Europe", "Europe/Prague");
        tempMap.put("Central Europe Standard Time", "Europe/Prague");
        tempMap.put("Prague Bratislava", "Europe/Prague");
        tempMap.put("W. Central Africa Standard Time", "Africa/Luanda");
        tempMap.put("FLE", "Europe/Helsinki");
        tempMap.put("FLE Standard Time", "Europe/Helsinki");
        tempMap.put("GFT", "Europe/Athens");
        tempMap.put("GFT Standard Time", "Europe/Athens");
        tempMap.put("GTB", "Europe/Athens");
        tempMap.put("GTB Standard Time", "Europe/Athens");
        tempMap.put("Israel", "Asia/Jerusalem");
        tempMap.put("Israel Standard Time", "Asia/Jerusalem");
        tempMap.put("Arab", "Asia/Riyadh");
        tempMap.put("Arab Standard Time", "Asia/Riyadh");
        tempMap.put("Arabic Standard Time", "Asia/Baghdad");
        tempMap.put("E. Africa", "Africa/Nairobi");
        tempMap.put("E. Africa Standard Time", "Africa/Nairobi");
        tempMap.put("Saudi Arabia", "Asia/Riyadh");
        tempMap.put("Saudi Arabia Standard Time", "Asia/Riyadh");
        tempMap.put("Iran", "Asia/Tehran");
        tempMap.put("Iran Standard Time", "Asia/Tehran");
        tempMap.put("Afghanistan", "Asia/Kabul");
        tempMap.put("Afghanistan Standard Time", "Asia/Kabul");
        tempMap.put("India", "Asia/Calcutta");
        tempMap.put("India Standard Time", "Asia/Calcutta");
        tempMap.put("Myanmar Standard Time", "Asia/Rangoon");
        tempMap.put("Nepal Standard Time", "Asia/Katmandu");
        tempMap.put("Sri Lanka", "Asia/Colombo");
        tempMap.put("Sri Lanka Standard Time", "Asia/Colombo");
        tempMap.put("Beijing", "Asia/Shanghai");
        tempMap.put("China", "Asia/Shanghai");
        tempMap.put("China Standard Time", "Asia/Shanghai");
        tempMap.put("AUS Central", "Australia/Darwin");
        tempMap.put("AUS Central Standard Time", "Australia/Darwin");
        tempMap.put("Cen. Australia", "Australia/Adelaide");
        tempMap.put("Cen. Australia Standard Time", "Australia/Adelaide");
        tempMap.put("Vladivostok", "Asia/Vladivostok");
        tempMap.put("Vladivostok Standard Time", "Asia/Vladivostok");
        tempMap.put("West Pacific", "Pacific/Guam");
        tempMap.put("West Pacific Standard Time", "Pacific/Guam");
        tempMap.put("E. South America", "America/Sao_Paulo");
        tempMap.put("E. South America Standard Time", "America/Sao_Paulo");
        tempMap.put("Greenland Standard Time", "America/Godthab");
        tempMap.put("Newfoundland", "America/St_Johns");
        tempMap.put("Newfoundland Standard Time", "America/St_Johns");
        tempMap.put("Pacific SA", "America/Caracas");
        tempMap.put("Pacific SA Standard Time", "America/Caracas");
        tempMap.put("SA Western", "America/Caracas");
        tempMap.put("SA Western Standard Time", "America/Caracas");
        tempMap.put("SA Pacific", "America/Bogota");
        tempMap.put("SA Pacific Standard Time", "America/Bogota");
        tempMap.put("US Eastern", "America/Indianapolis");
        tempMap.put("US Eastern Standard Time", "America/Indianapolis");
        tempMap.put("Central America Standard Time", "America/Regina");
        tempMap.put("Mexico", "America/Mexico_City");
        tempMap.put("Mexico Standard Time", "America/Mexico_City");
        tempMap.put("Canada Central", "America/Regina");
        tempMap.put("Canada Central Standard Time", "America/Regina");
        tempMap.put("US Mountain", "America/Phoenix");
        tempMap.put("US Mountain Standard Time", "America/Phoenix");
        tempMap.put("GMT", "Europe/London");
        tempMap.put("GMT Standard Time", "Europe/London");
        tempMap.put("Ekaterinburg", "Asia/Yekaterinburg");
        tempMap.put("Ekaterinburg Standard Time", "Asia/Yekaterinburg");
        tempMap.put("West Asia", "Asia/Karachi");
        tempMap.put("West Asia Standard Time", "Asia/Karachi");
        tempMap.put("Central Asia", "Asia/Dhaka");
        tempMap.put("Central Asia Standard Time", "Asia/Dhaka");
        tempMap.put("N. Central Asia Standard Time", "Asia/Novosibirsk");
        tempMap.put("Bangkok", "Asia/Bangkok");
        tempMap.put("Bangkok Standard Time", "Asia/Bangkok");
        tempMap.put("North Asia Standard Time", "Asia/Krasnoyarsk");
        tempMap.put("SE Asia", "Asia/Bangkok");
        tempMap.put("SE Asia Standard Time", "Asia/Bangkok");
        tempMap.put("North Asia East Standard Time", "Asia/Ulaanbaatar");
        tempMap.put("Singapore", "Asia/Singapore");
        tempMap.put("Singapore Standard Time", "Asia/Singapore");
        tempMap.put("Taipei", "Asia/Taipei");
        tempMap.put("Taipei Standard Time", "Asia/Taipei");
        tempMap.put("W. Australia", "Australia/Perth");
        tempMap.put("W. Australia Standard Time", "Australia/Perth");
        tempMap.put("Korea", "Asia/Seoul");
        tempMap.put("Korea Standard Time", "Asia/Seoul");
        tempMap.put("Tokyo", "Asia/Tokyo");
        tempMap.put("Tokyo Standard Time", "Asia/Tokyo");
        tempMap.put("Yakutsk", "Asia/Yakutsk");
        tempMap.put("Yakutsk Standard Time", "Asia/Yakutsk");
        tempMap.put("Central European", "Europe/Belgrade");
        tempMap.put("Central European Standard Time", "Europe/Belgrade");
        tempMap.put("W. Europe", "Europe/Berlin");
        tempMap.put("W. Europe Standard Time", "Europe/Berlin");
        tempMap.put("Tasmania", "Australia/Hobart");
        tempMap.put("Tasmania Standard Time", "Australia/Hobart");
        tempMap.put("AUS Eastern", "Australia/Sydney");
        tempMap.put("AUS Eastern Standard Time", "Australia/Sydney");
        tempMap.put("E. Australia", "Australia/Brisbane");
        tempMap.put("E. Australia Standard Time", "Australia/Brisbane");
        tempMap.put("Sydney Standard Time", "Australia/Sydney");
        tempMap.put("Central Pacific", "Pacific/Guadalcanal");
        tempMap.put("Central Pacific Standard Time", "Pacific/Guadalcanal");
        tempMap.put("Dateline", "Pacific/Majuro");
        tempMap.put("Dateline Standard Time", "Pacific/Majuro");
        tempMap.put("Fiji", "Pacific/Fiji");
        tempMap.put("Fiji Standard Time", "Pacific/Fiji");
        tempMap.put("Samoa", "Pacific/Apia");
        tempMap.put("Samoa Standard Time", "Pacific/Apia");
        tempMap.put("Hawaiian", "Pacific/Honolulu");
        tempMap.put("Hawaiian Standard Time", "Pacific/Honolulu");
        tempMap.put("Alaskan", "America/Anchorage");
        tempMap.put("Alaskan Standard Time", "America/Anchorage");
        tempMap.put("Pacific", "America/Los_Angeles");
        tempMap.put("Pacific Standard Time", "America/Los_Angeles");
        tempMap.put("Mexico Standard Time 2", "America/Chihuahua");
        tempMap.put("Mountain", "America/Denver");
        tempMap.put("Mountain Standard Time", "America/Denver");
        tempMap.put("Central", "America/Chicago");
        tempMap.put("Central Standard Time", "America/Chicago");
        tempMap.put("Eastern", "America/New_York");
        tempMap.put("Eastern Standard Time", "America/New_York");
        tempMap.put("E. Europe", "Europe/Bucharest");
        tempMap.put("E. Europe Standard Time", "Europe/Bucharest");
        tempMap.put("Egypt", "Africa/Cairo");
        tempMap.put("Egypt Standard Time", "Africa/Cairo");
        tempMap.put("South Africa", "Africa/Harare");
        tempMap.put("South Africa Standard Time", "Africa/Harare");
        tempMap.put("Atlantic", "America/Halifax");
        tempMap.put("Atlantic Standard Time", "America/Halifax");
        tempMap.put("SA Eastern", "America/Buenos_Aires");
        tempMap.put("SA Eastern Standard Time", "America/Buenos_Aires");
        tempMap.put("Mid-Atlantic", "Atlantic/South_Georgia");
        tempMap.put("Mid-Atlantic Standard Time", "Atlantic/South_Georgia");
        tempMap.put("Azores", "Atlantic/Azores");
        tempMap.put("Azores Standard Time", "Atlantic/Azores");
        tempMap.put("Cape Verde Standard Time", "Atlantic/Cape_Verde");
        tempMap.put("Russian", "Europe/Moscow");
        tempMap.put("Russian Standard Time", "Europe/Moscow");
        tempMap.put("New Zealand", "Pacific/Auckland");
        tempMap.put("New Zealand Standard Time", "Pacific/Auckland");
        tempMap.put("Tonga Standard Time", "Pacific/Tongatapu");
        tempMap.put("Arabian", "Asia/Muscat");
        tempMap.put("Arabian Standard Time", "Asia/Muscat");
        tempMap.put("Caucasus", "Asia/Tbilisi");
        tempMap.put("Caucasus Standard Time", "Asia/Tbilisi");
        tempMap.put("GMT Standard Time", "GMT");
        tempMap.put("Greenwich", "GMT");
        tempMap.put("Greenwich Standard Time", "GMT");
        tempMap.put("UTC", "GMT");

        TIMEZONE_MAPPINGS = Collections.unmodifiableMap(tempMap);

        //
        // Handle abbreviated mappings
        //
        tempMap = new HashMap();

        tempMap.put("ACST", new String[] { "America/Porto_Acre" });
        tempMap.put("ACT", new String[] { "America/Porto_Acre" });
        tempMap.put("ADDT", new String[] { "America/Pangnirtung" });
        tempMap.put("ADMT",
            new String[] { "Africa/Asmera", "Africa/Addis_Ababa" });
        tempMap.put("ADT",
            new String[] {
                "Atlantic/Bermuda", "Asia/Baghdad", "America/Thule",
                "America/Goose_Bay", "America/Halifax", "America/Glace_Bay",
                "America/Pangnirtung", "America/Barbados", "America/Martinique"
            });
        tempMap.put("AFT", new String[] { "Asia/Kabul" });
        tempMap.put("AHDT", new String[] { "America/Anchorage" });
        tempMap.put("AHST", new String[] { "America/Anchorage" });
        tempMap.put("AHWT", new String[] { "America/Anchorage" });
        tempMap.put("AKDT",
            new String[] {
                "America/Juneau", "America/Yakutat", "America/Anchorage",
                "America/Nome"
            });
        tempMap.put("AKST",
            new String[] {
                "Asia/Aqtobe", "America/Juneau", "America/Yakutat",
                "America/Anchorage", "America/Nome"
            });
        tempMap.put("AKT", new String[] { "Asia/Aqtobe" });
        tempMap.put("AKTST", new String[] { "Asia/Aqtobe" });
        tempMap.put("AKWT",
            new String[] {
                "America/Juneau", "America/Yakutat", "America/Anchorage",
                "America/Nome"
            });
        tempMap.put("ALMST", new String[] { "Asia/Almaty" });
        tempMap.put("ALMT", new String[] { "Asia/Almaty" });
        tempMap.put("AMST",
            new String[] {
                "Asia/Yerevan", "America/Cuiaba", "America/Porto_Velho",
                "America/Boa_Vista", "America/Manaus"
            });
        tempMap.put("AMT",
            new String[] {
                "Europe/Athens", "Europe/Amsterdam", "Asia/Yerevan",
                "Africa/Asmera", "America/Cuiaba", "America/Porto_Velho",
                "America/Boa_Vista", "America/Manaus", "America/Asuncion"
            });
        tempMap.put("ANAMT", new String[] { "Asia/Anadyr" });
        tempMap.put("ANAST", new String[] { "Asia/Anadyr" });
        tempMap.put("ANAT", new String[] { "Asia/Anadyr" });
        tempMap.put("ANT", new String[] { "America/Aruba", "America/Curacao" });
        tempMap.put("AQTST", new String[] { "Asia/Aqtobe", "Asia/Aqtau" });
        tempMap.put("AQTT", new String[] { "Asia/Aqtobe", "Asia/Aqtau" });
        tempMap.put("ARST",
            new String[] {
                "Antarctica/Palmer", "America/Buenos_Aires", "America/Rosario",
                "America/Cordoba", "America/Jujuy", "America/Catamarca",
                "America/Mendoza"
            });
        tempMap.put("ART",
            new String[] {
                "Antarctica/Palmer", "America/Buenos_Aires", "America/Rosario",
                "America/Cordoba", "America/Jujuy", "America/Catamarca",
                "America/Mendoza"
            });
        tempMap.put("ASHST", new String[] { "Asia/Ashkhabad" });
        tempMap.put("ASHT", new String[] { "Asia/Ashkhabad" });
        tempMap.put("AST",
            new String[] {
                "Atlantic/Bermuda", "Asia/Bahrain", "Asia/Baghdad",
                "Asia/Kuwait", "Asia/Qatar", "Asia/Riyadh", "Asia/Aden",
                "America/Thule", "America/Goose_Bay", "America/Halifax",
                "America/Glace_Bay", "America/Pangnirtung", "America/Anguilla",
                "America/Antigua", "America/Barbados", "America/Dominica",
                "America/Santo_Domingo", "America/Grenada", "America/Guadeloupe",
                "America/Martinique", "America/Montserrat",
                "America/Puerto_Rico", "America/St_Kitts", "America/St_Lucia",
                "America/Miquelon", "America/St_Vincent", "America/Tortola",
                "America/St_Thomas", "America/Aruba", "America/Curacao",
                "America/Port_of_Spain"
            });
        tempMap.put("AWT", new String[] { "America/Puerto_Rico" });
        tempMap.put("AZOST", new String[] { "Atlantic/Azores" });
        tempMap.put("AZOT", new String[] { "Atlantic/Azores" });
        tempMap.put("AZST", new String[] { "Asia/Baku" });
        tempMap.put("AZT", new String[] { "Asia/Baku" });
        tempMap.put("BAKST", new String[] { "Asia/Baku" });
        tempMap.put("BAKT", new String[] { "Asia/Baku" });
        tempMap.put("BDT",
            new String[] { "Asia/Dacca", "America/Nome", "America/Adak" });
        tempMap.put("BEAT",
            new String[] { "Africa/Nairobi", "Africa/Mogadishu", "Africa/Kampala" });
        tempMap.put("BEAUT",
            new String[] {
                "Africa/Nairobi", "Africa/Dar_es_Salaam", "Africa/Kampala"
            });
        tempMap.put("BMT",
            new String[] {
                "Europe/Brussels", "Europe/Chisinau", "Europe/Tiraspol",
                "Europe/Bucharest", "Europe/Zurich", "Asia/Baghdad",
                "Asia/Bangkok", "Africa/Banjul", "America/Barbados",
                "America/Bogota"
            });
        tempMap.put("BNT", new String[] { "Asia/Brunei" });
        tempMap.put("BORT",
            new String[] { "Asia/Ujung_Pandang", "Asia/Kuching" });
        tempMap.put("BOST", new String[] { "America/La_Paz" });
        tempMap.put("BOT", new String[] { "America/La_Paz" });
        tempMap.put("BRST",
            new String[] {
                "America/Belem", "America/Fortaleza", "America/Araguaina",
                "America/Maceio", "America/Sao_Paulo"
            });
        tempMap.put("BRT",
            new String[] {
                "America/Belem", "America/Fortaleza", "America/Araguaina",
                "America/Maceio", "America/Sao_Paulo"
            });
        tempMap.put("BST",
            new String[] {
                "Europe/London", "Europe/Belfast", "Europe/Dublin",
                "Europe/Gibraltar", "Pacific/Pago_Pago", "Pacific/Midway",
                "America/Nome", "America/Adak"
            });
        tempMap.put("BTT", new String[] { "Asia/Thimbu" });
        tempMap.put("BURT",
            new String[] { "Asia/Dacca", "Asia/Rangoon", "Asia/Calcutta" });
        tempMap.put("BWT", new String[] { "America/Nome", "America/Adak" });
        tempMap.put("CANT", new String[] { "Atlantic/Canary" });
        tempMap.put("CAST",
            new String[] { "Africa/Gaborone", "Africa/Khartoum" });
        tempMap.put("CAT",
            new String[] {
                "Africa/Gaborone", "Africa/Bujumbura", "Africa/Lubumbashi",
                "Africa/Blantyre", "Africa/Maputo", "Africa/Windhoek",
                "Africa/Kigali", "Africa/Khartoum", "Africa/Lusaka",
                "Africa/Harare", "America/Anchorage"
            });
        tempMap.put("CCT", new String[] { "Indian/Cocos" });
        tempMap.put("CDDT", new String[] { "America/Rankin_Inlet" });
        tempMap.put("CDT",
            new String[] {
                "Asia/Harbin", "Asia/Shanghai", "Asia/Chungking", "Asia/Urumqi",
                "Asia/Kashgar", "Asia/Taipei", "Asia/Macao", "America/Chicago",
                "America/Indianapolis", "America/Indiana/Marengo",
                "America/Indiana/Knox", "America/Indiana/Vevay",
                "America/Louisville", "America/Menominee", "America/Rainy_River",
                "America/Winnipeg", "America/Pangnirtung", "America/Iqaluit",
                "America/Rankin_Inlet", "America/Cambridge_Bay",
                "America/Cancun", "America/Mexico_City", "America/Chihuahua",
                "America/Belize", "America/Costa_Rica", "America/Havana",
                "America/El_Salvador", "America/Guatemala",
                "America/Tegucigalpa", "America/Managua"
            });
        tempMap.put("CEST",
            new String[] {
                "Europe/Tirane", "Europe/Andorra", "Europe/Vienna",
                "Europe/Minsk", "Europe/Brussels", "Europe/Sofia",
                "Europe/Prague", "Europe/Copenhagen", "Europe/Tallinn",
                "Europe/Berlin", "Europe/Gibraltar", "Europe/Athens",
                "Europe/Budapest", "Europe/Rome", "Europe/Riga", "Europe/Vaduz",
                "Europe/Vilnius", "Europe/Luxembourg", "Europe/Malta",
                "Europe/Chisinau", "Europe/Tiraspol", "Europe/Monaco",
                "Europe/Amsterdam", "Europe/Oslo", "Europe/Warsaw",
                "Europe/Lisbon", "Europe/Kaliningrad", "Europe/Madrid",
                "Europe/Stockholm", "Europe/Zurich", "Europe/Kiev",
                "Europe/Uzhgorod", "Europe/Zaporozhye", "Europe/Simferopol",
                "Europe/Belgrade", "Africa/Algiers", "Africa/Tripoli",
                "Africa/Tunis", "Africa/Ceuta"
            });
        tempMap.put("CET",
            new String[] {
                "Europe/Tirane", "Europe/Andorra", "Europe/Vienna",
                "Europe/Minsk", "Europe/Brussels", "Europe/Sofia",
                "Europe/Prague", "Europe/Copenhagen", "Europe/Tallinn",
                "Europe/Berlin", "Europe/Gibraltar", "Europe/Athens",
                "Europe/Budapest", "Europe/Rome", "Europe/Riga", "Europe/Vaduz",
                "Europe/Vilnius", "Europe/Luxembourg", "Europe/Malta",
                "Europe/Chisinau", "Europe/Tiraspol", "Europe/Monaco",
                "Europe/Amsterdam", "Europe/Oslo", "Europe/Warsaw",
                "Europe/Lisbon", "Europe/Kaliningrad", "Europe/Madrid",
                "Europe/Stockholm", "Europe/Zurich", "Europe/Kiev",
                "Europe/Uzhgorod", "Europe/Zaporozhye", "Europe/Simferopol",
                "Europe/Belgrade", "Africa/Algiers", "Africa/Tripoli",
                "Africa/Casablanca", "Africa/Tunis", "Africa/Ceuta"
            });
        tempMap.put("CGST", new String[] { "America/Scoresbysund" });
        tempMap.put("CGT", new String[] { "America/Scoresbysund" });
        tempMap.put("CHDT", new String[] { "America/Belize" });
        tempMap.put("CHUT", new String[] { "Asia/Chungking" });
        tempMap.put("CJT", new String[] { "Asia/Tokyo" });
        tempMap.put("CKHST", new String[] { "Pacific/Rarotonga" });
        tempMap.put("CKT", new String[] { "Pacific/Rarotonga" });
        tempMap.put("CLST",
            new String[] { "Antarctica/Palmer", "America/Santiago" });
        tempMap.put("CLT",
            new String[] { "Antarctica/Palmer", "America/Santiago" });
        tempMap.put("CMT",
            new String[] {
                "Europe/Copenhagen", "Europe/Chisinau", "Europe/Tiraspol",
                "America/St_Lucia", "America/Buenos_Aires", "America/Rosario",
                "America/Cordoba", "America/Jujuy", "America/Catamarca",
                "America/Mendoza", "America/Caracas"
            });
        tempMap.put("COST", new String[] { "America/Bogota" });
        tempMap.put("COT", new String[] { "America/Bogota" });
        tempMap.put("CST",
            new String[] {
                "Asia/Harbin", "Asia/Shanghai", "Asia/Chungking", "Asia/Urumqi",
                "Asia/Kashgar", "Asia/Taipei", "Asia/Macao", "Asia/Jayapura",
                "Australia/Darwin", "Australia/Adelaide",
                "Australia/Broken_Hill", "America/Chicago",
                "America/Indianapolis", "America/Indiana/Marengo",
                "America/Indiana/Knox", "America/Indiana/Vevay",
                "America/Louisville", "America/Detroit", "America/Menominee",
                "America/Rainy_River", "America/Winnipeg", "America/Regina",
                "America/Swift_Current", "America/Pangnirtung",
                "America/Iqaluit", "America/Rankin_Inlet",
                "America/Cambridge_Bay", "America/Cancun", "America/Mexico_City",
                "America/Chihuahua", "America/Hermosillo", "America/Mazatlan",
                "America/Belize", "America/Costa_Rica", "America/Havana",
                "America/El_Salvador", "America/Guatemala",
                "America/Tegucigalpa", "America/Managua"
            });
        tempMap.put("CUT", new String[] { "Europe/Zaporozhye" });
        tempMap.put("CVST", new String[] { "Atlantic/Cape_Verde" });
        tempMap.put("CVT", new String[] { "Atlantic/Cape_Verde" });
        tempMap.put("CWT",
            new String[] {
                "America/Chicago", "America/Indianapolis",
                "America/Indiana/Marengo", "America/Indiana/Knox",
                "America/Indiana/Vevay", "America/Louisville",
                "America/Menominee"
            });
        tempMap.put("CXT", new String[] { "Indian/Christmas" });
        tempMap.put("DACT", new String[] { "Asia/Dacca" });
        tempMap.put("DAVT", new String[] { "Antarctica/Davis" });
        tempMap.put("DDUT", new String[] { "Antarctica/DumontDUrville" });
        tempMap.put("DFT", new String[] { "Europe/Oslo", "Europe/Paris" });
        tempMap.put("DMT", new String[] { "Europe/Belfast", "Europe/Dublin" });
        tempMap.put("DUSST", new String[] { "Asia/Dushanbe" });
        tempMap.put("DUST", new String[] { "Asia/Dushanbe" });
        tempMap.put("EASST", new String[] { "Pacific/Easter" });
        tempMap.put("EAST",
            new String[] { "Indian/Antananarivo", "Pacific/Easter" });
        tempMap.put("EAT",
            new String[] {
                "Indian/Comoro", "Indian/Antananarivo", "Indian/Mayotte",
                "Africa/Djibouti", "Africa/Asmera", "Africa/Addis_Ababa",
                "Africa/Nairobi", "Africa/Mogadishu", "Africa/Khartoum",
                "Africa/Dar_es_Salaam", "Africa/Kampala"
            });
        tempMap.put("ECT",
            new String[] { "Pacific/Galapagos", "America/Guayaquil" });
        tempMap.put("EDDT", new String[] { "America/Iqaluit" });
        tempMap.put("EDT",
            new String[] {
                "America/New_York", "America/Indianapolis",
                "America/Indiana/Marengo", "America/Indiana/Vevay",
                "America/Louisville", "America/Detroit", "America/Montreal",
                "America/Thunder_Bay", "America/Nipigon", "America/Pangnirtung",
                "America/Iqaluit", "America/Cancun", "America/Nassau",
                "America/Santo_Domingo", "America/Port-au-Prince",
                "America/Jamaica", "America/Grand_Turk"
            });
        tempMap.put("EEMT",
            new String[] {
                "Europe/Minsk", "Europe/Chisinau", "Europe/Tiraspol",
                "Europe/Kaliningrad", "Europe/Moscow"
            });
        tempMap.put("EEST",
            new String[] {
                "Europe/Minsk", "Europe/Sofia", "Europe/Tallinn",
                "Europe/Helsinki", "Europe/Athens", "Europe/Riga",
                "Europe/Vilnius", "Europe/Chisinau", "Europe/Tiraspol",
                "Europe/Warsaw", "Europe/Bucharest", "Europe/Kaliningrad",
                "Europe/Moscow", "Europe/Istanbul", "Europe/Kiev",
                "Europe/Uzhgorod", "Europe/Zaporozhye", "Asia/Nicosia",
                "Asia/Amman", "Asia/Beirut", "Asia/Gaza", "Asia/Damascus",
                "Africa/Cairo"
            });
        tempMap.put("EET",
            new String[] {
                "Europe/Minsk", "Europe/Sofia", "Europe/Tallinn",
                "Europe/Helsinki", "Europe/Athens", "Europe/Riga",
                "Europe/Vilnius", "Europe/Chisinau", "Europe/Tiraspol",
                "Europe/Warsaw", "Europe/Bucharest", "Europe/Kaliningrad",
                "Europe/Moscow", "Europe/Istanbul", "Europe/Kiev",
                "Europe/Uzhgorod", "Europe/Zaporozhye", "Europe/Simferopol",
                "Asia/Nicosia", "Asia/Amman", "Asia/Beirut", "Asia/Gaza",
                "Asia/Damascus", "Africa/Cairo", "Africa/Tripoli"
            });
        tempMap.put("EGST", new String[] { "America/Scoresbysund" });
        tempMap.put("EGT",
            new String[] { "Atlantic/Jan_Mayen", "America/Scoresbysund" });
        tempMap.put("EHDT", new String[] { "America/Santo_Domingo" });
        tempMap.put("EST",
            new String[] {
                "Australia/Brisbane", "Australia/Lindeman", "Australia/Hobart",
                "Australia/Melbourne", "Australia/Sydney",
                "Australia/Broken_Hill", "Australia/Lord_Howe",
                "America/New_York", "America/Chicago", "America/Indianapolis",
                "America/Indiana/Marengo", "America/Indiana/Knox",
                "America/Indiana/Vevay", "America/Louisville", "America/Detroit",
                "America/Menominee", "America/Montreal", "America/Thunder_Bay",
                "America/Nipigon", "America/Pangnirtung", "America/Iqaluit",
                "America/Cancun", "America/Antigua", "America/Nassau",
                "America/Cayman", "America/Santo_Domingo",
                "America/Port-au-Prince", "America/Jamaica", "America/Managua",
                "America/Panama", "America/Grand_Turk"
            });
        tempMap.put("EWT",
            new String[] {
                "America/New_York", "America/Indianapolis",
                "America/Indiana/Marengo", "America/Indiana/Vevay",
                "America/Louisville", "America/Detroit", "America/Jamaica"
            });
        tempMap.put("FFMT", new String[] { "America/Martinique" });
        tempMap.put("FJST", new String[] { "Pacific/Fiji" });
        tempMap.put("FJT", new String[] { "Pacific/Fiji" });
        tempMap.put("FKST", new String[] { "Atlantic/Stanley" });
        tempMap.put("FKT", new String[] { "Atlantic/Stanley" });
        tempMap.put("FMT",
            new String[] { "Atlantic/Madeira", "Africa/Freetown" });
        tempMap.put("FNST", new String[] { "America/Noronha" });
        tempMap.put("FNT", new String[] { "America/Noronha" });
        tempMap.put("FRUST", new String[] { "Asia/Bishkek" });
        tempMap.put("FRUT", new String[] { "Asia/Bishkek" });
        tempMap.put("GALT", new String[] { "Pacific/Galapagos" });
        tempMap.put("GAMT", new String[] { "Pacific/Gambier" });
        tempMap.put("GBGT", new String[] { "America/Guyana" });
        tempMap.put("GEST", new String[] { "Asia/Tbilisi" });
        tempMap.put("GET", new String[] { "Asia/Tbilisi" });
        tempMap.put("GFT", new String[] { "America/Cayenne" });
        tempMap.put("GHST", new String[] { "Africa/Accra" });
        tempMap.put("GILT", new String[] { "Pacific/Tarawa" });
        tempMap.put("GMT",
            new String[] {
                "Atlantic/St_Helena", "Atlantic/Reykjavik", "Europe/London",
                "Europe/Belfast", "Europe/Dublin", "Europe/Gibraltar",
                "Africa/Porto-Novo", "Africa/Ouagadougou", "Africa/Abidjan",
                "Africa/Malabo", "Africa/Banjul", "Africa/Accra",
                "Africa/Conakry", "Africa/Bissau", "Africa/Monrovia",
                "Africa/Bamako", "Africa/Timbuktu", "Africa/Nouakchott",
                "Africa/Niamey", "Africa/Sao_Tome", "Africa/Dakar",
                "Africa/Freetown", "Africa/Lome"
            });
        tempMap.put("GST",
            new String[] {
                "Atlantic/South_Georgia", "Asia/Bahrain", "Asia/Muscat",
                "Asia/Qatar", "Asia/Dubai", "Pacific/Guam"
            });
        tempMap.put("GYT", new String[] { "America/Guyana" });
        tempMap.put("HADT", new String[] { "America/Adak" });
        tempMap.put("HART", new String[] { "Asia/Harbin" });
        tempMap.put("HAST", new String[] { "America/Adak" });
        tempMap.put("HAWT", new String[] { "America/Adak" });
        tempMap.put("HDT", new String[] { "Pacific/Honolulu" });
        tempMap.put("HKST", new String[] { "Asia/Hong_Kong" });
        tempMap.put("HKT", new String[] { "Asia/Hong_Kong" });
        tempMap.put("HMT",
            new String[] {
                "Atlantic/Azores", "Europe/Helsinki", "Asia/Dacca",
                "Asia/Calcutta", "America/Havana"
            });
        tempMap.put("HOVST", new String[] { "Asia/Hovd" });
        tempMap.put("HOVT", new String[] { "Asia/Hovd" });
        tempMap.put("HST",
            new String[] { "Pacific/Johnston", "Pacific/Honolulu" });
        tempMap.put("HWT", new String[] { "Pacific/Honolulu" });
        tempMap.put("ICT",
            new String[] {
                "Asia/Phnom_Penh", "Asia/Vientiane", "Asia/Bangkok",
                "Asia/Saigon"
            });
        tempMap.put("IDDT", new String[] { "Asia/Jerusalem", "Asia/Gaza" });
        tempMap.put("IDT", new String[] { "Asia/Jerusalem", "Asia/Gaza" });
        tempMap.put("IHST", new String[] { "Asia/Colombo" });
        tempMap.put("IMT",
            new String[] { "Europe/Sofia", "Europe/Istanbul", "Asia/Irkutsk" });
        tempMap.put("IOT", new String[] { "Indian/Chagos" });
        tempMap.put("IRKMT", new String[] { "Asia/Irkutsk" });
        tempMap.put("IRKST", new String[] { "Asia/Irkutsk" });
        tempMap.put("IRKT", new String[] { "Asia/Irkutsk" });
        tempMap.put("IRST", new String[] { "Asia/Tehran" });
        tempMap.put("IRT", new String[] { "Asia/Tehran" });
        tempMap.put("ISST", new String[] { "Atlantic/Reykjavik" });
        tempMap.put("IST",
            new String[] {
                "Atlantic/Reykjavik", "Europe/Belfast", "Europe/Dublin",
                "Asia/Dacca", "Asia/Thimbu", "Asia/Calcutta", "Asia/Jerusalem",
                "Asia/Katmandu", "Asia/Karachi", "Asia/Gaza", "Asia/Colombo"
            });
        tempMap.put("JAYT", new String[] { "Asia/Jayapura" });
        tempMap.put("JMT",
            new String[] { "Atlantic/St_Helena", "Asia/Jerusalem" });
        tempMap.put("JST",
            new String[] {
                "Asia/Rangoon", "Asia/Dili", "Asia/Ujung_Pandang", "Asia/Tokyo",
                "Asia/Kuala_Lumpur", "Asia/Kuching", "Asia/Manila",
                "Asia/Singapore", "Pacific/Nauru"
            });
        tempMap.put("KART", new String[] { "Asia/Karachi" });
        tempMap.put("KAST", new String[] { "Asia/Kashgar" });
        tempMap.put("KDT", new String[] { "Asia/Seoul" });
        tempMap.put("KGST", new String[] { "Asia/Bishkek" });
        tempMap.put("KGT", new String[] { "Asia/Bishkek" });
        tempMap.put("KMT",
            new String[] {
                "Europe/Vilnius", "Europe/Kiev", "America/Cayman",
                "America/Jamaica", "America/St_Vincent", "America/Grand_Turk"
            });
        tempMap.put("KOST", new String[] { "Pacific/Kosrae" });
        tempMap.put("KRAMT", new String[] { "Asia/Krasnoyarsk" });
        tempMap.put("KRAST", new String[] { "Asia/Krasnoyarsk" });
        tempMap.put("KRAT", new String[] { "Asia/Krasnoyarsk" });
        tempMap.put("KST", new String[] { "Asia/Seoul", "Asia/Pyongyang" });
        tempMap.put("KUYMT", new String[] { "Europe/Samara" });
        tempMap.put("KUYST", new String[] { "Europe/Samara" });
        tempMap.put("KUYT", new String[] { "Europe/Samara" });
        tempMap.put("KWAT", new String[] { "Pacific/Kwajalein" });
        tempMap.put("LHST", new String[] { "Australia/Lord_Howe" });
        tempMap.put("LINT", new String[] { "Pacific/Kiritimati" });
        tempMap.put("LKT", new String[] { "Asia/Colombo" });
        tempMap.put("LPMT", new String[] { "America/La_Paz" });
        tempMap.put("LRT", new String[] { "Africa/Monrovia" });
        tempMap.put("LST", new String[] { "Europe/Riga" });
        tempMap.put("M", new String[] { "Europe/Moscow" });
        tempMap.put("MADST", new String[] { "Atlantic/Madeira" });
        tempMap.put("MAGMT", new String[] { "Asia/Magadan" });
        tempMap.put("MAGST", new String[] { "Asia/Magadan" });
        tempMap.put("MAGT", new String[] { "Asia/Magadan" });
        tempMap.put("MALT",
            new String[] { "Asia/Kuala_Lumpur", "Asia/Singapore" });
        tempMap.put("MART", new String[] { "Pacific/Marquesas" });
        tempMap.put("MAWT", new String[] { "Antarctica/Mawson" });
        tempMap.put("MDDT",
            new String[] {
                "America/Cambridge_Bay", "America/Yellowknife", "America/Inuvik"
            });
        tempMap.put("MDST", new String[] { "Europe/Moscow" });
        tempMap.put("MDT",
            new String[] {
                "America/Denver", "America/Phoenix", "America/Boise",
                "America/Regina", "America/Swift_Current", "America/Edmonton",
                "America/Cambridge_Bay", "America/Yellowknife", "America/Inuvik",
                "America/Chihuahua", "America/Hermosillo", "America/Mazatlan"
            });
        tempMap.put("MET",
            new String[] {
                "Europe/Tirane", "Europe/Andorra", "Europe/Vienna",
                "Europe/Minsk", "Europe/Brussels", "Europe/Sofia",
                "Europe/Prague", "Europe/Copenhagen", "Europe/Tallinn",
                "Europe/Berlin", "Europe/Gibraltar", "Europe/Athens",
                "Europe/Budapest", "Europe/Rome", "Europe/Riga", "Europe/Vaduz",
                "Europe/Vilnius", "Europe/Luxembourg", "Europe/Malta",
                "Europe/Chisinau", "Europe/Tiraspol", "Europe/Monaco",
                "Europe/Amsterdam", "Europe/Oslo", "Europe/Warsaw",
                "Europe/Lisbon", "Europe/Kaliningrad", "Europe/Madrid",
                "Europe/Stockholm", "Europe/Zurich", "Europe/Kiev",
                "Europe/Uzhgorod", "Europe/Zaporozhye", "Europe/Simferopol",
                "Europe/Belgrade", "Africa/Algiers", "Africa/Tripoli",
                "Africa/Casablanca", "Africa/Tunis", "Africa/Ceuta"
            });
        tempMap.put("MHT",
            new String[] { "Pacific/Majuro", "Pacific/Kwajalein" });
        tempMap.put("MMT",
            new String[] {
                "Indian/Maldives", "Europe/Minsk", "Europe/Moscow",
                "Asia/Rangoon", "Asia/Ujung_Pandang", "Asia/Colombo",
                "Pacific/Easter", "Africa/Monrovia", "America/Managua",
                "America/Montevideo"
            });
        tempMap.put("MOST", new String[] { "Asia/Macao" });
        tempMap.put("MOT", new String[] { "Asia/Macao" });
        tempMap.put("MPT", new String[] { "Pacific/Saipan" });
        tempMap.put("MSK",
            new String[] {
                "Europe/Minsk", "Europe/Tallinn", "Europe/Riga",
                "Europe/Vilnius", "Europe/Chisinau", "Europe/Kiev",
                "Europe/Uzhgorod", "Europe/Zaporozhye", "Europe/Simferopol"
            });
        tempMap.put("MST",
            new String[] {
                "Europe/Moscow", "America/Denver", "America/Phoenix",
                "America/Boise", "America/Regina", "America/Swift_Current",
                "America/Edmonton", "America/Dawson_Creek",
                "America/Cambridge_Bay", "America/Yellowknife", "America/Inuvik",
                "America/Mexico_City", "America/Chihuahua", "America/Hermosillo",
                "America/Mazatlan", "America/Tijuana"
            });
        tempMap.put("MUT", new String[] { "Indian/Mauritius" });
        tempMap.put("MVT", new String[] { "Indian/Maldives" });
        tempMap.put("MWT",
            new String[] { "America/Denver", "America/Phoenix", "America/Boise" });
        tempMap.put("MYT", new String[] { "Asia/Kuala_Lumpur", "Asia/Kuching" });
        tempMap.put("NCST", new String[] { "Pacific/Noumea" });
        tempMap.put("NCT", new String[] { "Pacific/Noumea" });
        tempMap.put("NDT",
            new String[] {
                "America/Nome", "America/Adak", "America/St_Johns",
                "America/Goose_Bay"
            });
        tempMap.put("NEGT", new String[] { "America/Paramaribo" });
        tempMap.put("NFT",
            new String[] { "Europe/Paris", "Europe/Oslo", "Pacific/Norfolk" });
        tempMap.put("NMT", new String[] { "Pacific/Norfolk" });
        tempMap.put("NOVMT", new String[] { "Asia/Novosibirsk" });
        tempMap.put("NOVST", new String[] { "Asia/Novosibirsk" });
        tempMap.put("NOVT", new String[] { "Asia/Novosibirsk" });
        tempMap.put("NPT", new String[] { "Asia/Katmandu" });
        tempMap.put("NRT", new String[] { "Pacific/Nauru" });
        tempMap.put("NST",
            new String[] {
                "Europe/Amsterdam", "Pacific/Pago_Pago", "Pacific/Midway",
                "America/Nome", "America/Adak", "America/St_Johns",
                "America/Goose_Bay"
            });
        tempMap.put("NUT", new String[] { "Pacific/Niue" });
        tempMap.put("NWT", new String[] { "America/Nome", "America/Adak" });
        tempMap.put("NZDT", new String[] { "Antarctica/McMurdo" });
        tempMap.put("NZHDT", new String[] { "Pacific/Auckland" });
        tempMap.put("NZST",
            new String[] { "Antarctica/McMurdo", "Pacific/Auckland" });
        tempMap.put("OMSMT", new String[] { "Asia/Omsk" });
        tempMap.put("OMSST", new String[] { "Asia/Omsk" });
        tempMap.put("OMST", new String[] { "Asia/Omsk" });
        tempMap.put("PDDT",
            new String[] {
                "America/Inuvik", "America/Whitehorse", "America/Dawson"
            });
        tempMap.put("PDT",
            new String[] {
                "America/Los_Angeles", "America/Juneau", "America/Boise",
                "America/Vancouver", "America/Dawson_Creek", "America/Inuvik",
                "America/Whitehorse", "America/Dawson", "America/Tijuana"
            });
        tempMap.put("PEST", new String[] { "America/Lima" });
        tempMap.put("PET", new String[] { "America/Lima" });
        tempMap.put("PETMT", new String[] { "Asia/Kamchatka" });
        tempMap.put("PETST", new String[] { "Asia/Kamchatka" });
        tempMap.put("PETT", new String[] { "Asia/Kamchatka" });
        tempMap.put("PGT", new String[] { "Pacific/Port_Moresby" });
        tempMap.put("PHOT", new String[] { "Pacific/Enderbury" });
        tempMap.put("PHST", new String[] { "Asia/Manila" });
        tempMap.put("PHT", new String[] { "Asia/Manila" });
        tempMap.put("PKT", new String[] { "Asia/Karachi" });
        tempMap.put("PMDT", new String[] { "America/Miquelon" });
        tempMap.put("PMMT", new String[] { "Pacific/Port_Moresby" });
        tempMap.put("PMST", new String[] { "America/Miquelon" });
        tempMap.put("PMT",
            new String[] {
                "Antarctica/DumontDUrville", "Europe/Prague", "Europe/Paris",
                "Europe/Monaco", "Africa/Algiers", "Africa/Tunis",
                "America/Panama", "America/Paramaribo"
            });
        tempMap.put("PNT", new String[] { "Pacific/Pitcairn" });
        tempMap.put("PONT", new String[] { "Pacific/Ponape" });
        tempMap.put("PPMT", new String[] { "America/Port-au-Prince" });
        tempMap.put("PST",
            new String[] {
                "Pacific/Pitcairn", "America/Los_Angeles", "America/Juneau",
                "America/Boise", "America/Vancouver", "America/Dawson_Creek",
                "America/Inuvik", "America/Whitehorse", "America/Dawson",
                "America/Hermosillo", "America/Mazatlan", "America/Tijuana"
            });
        tempMap.put("PWT",
            new String[] {
                "Pacific/Palau", "America/Los_Angeles", "America/Juneau",
                "America/Boise", "America/Tijuana"
            });
        tempMap.put("PYST", new String[] { "America/Asuncion" });
        tempMap.put("PYT", new String[] { "America/Asuncion" });
        tempMap.put("QMT", new String[] { "America/Guayaquil" });
        tempMap.put("RET", new String[] { "Indian/Reunion" });
        tempMap.put("RMT",
            new String[] {
                "Atlantic/Reykjavik", "Europe/Rome", "Europe/Riga",
                "Asia/Rangoon"
            });
        tempMap.put("S", new String[] { "Europe/Moscow" });
        tempMap.put("SAMMT", new String[] { "Europe/Samara" });
        tempMap.put("SAMST", new String[] { "Europe/Samara", "Asia/Samarkand" });
        tempMap.put("SAMT",
            new String[] {
                "Europe/Samara", "Asia/Samarkand", "Pacific/Pago_Pago",
                "Pacific/Apia"
            });
        tempMap.put("SAST",
            new String[] {
                "Africa/Maseru", "Africa/Windhoek", "Africa/Johannesburg",
                "Africa/Mbabane"
            });
        tempMap.put("SBT", new String[] { "Pacific/Guadalcanal" });
        tempMap.put("SCT", new String[] { "Indian/Mahe" });
        tempMap.put("SDMT", new String[] { "America/Santo_Domingo" });
        tempMap.put("SGT", new String[] { "Asia/Singapore" });
        tempMap.put("SHEST", new String[] { "Asia/Aqtau" });
        tempMap.put("SHET", new String[] { "Asia/Aqtau" });
        tempMap.put("SJMT", new String[] { "America/Costa_Rica" });
        tempMap.put("SLST", new String[] { "Africa/Freetown" });
        tempMap.put("SMT",
            new String[] {
                "Atlantic/Stanley", "Europe/Stockholm", "Europe/Simferopol",
                "Asia/Phnom_Penh", "Asia/Vientiane", "Asia/Kuala_Lumpur",
                "Asia/Singapore", "Asia/Saigon", "America/Santiago"
            });
        tempMap.put("SRT", new String[] { "America/Paramaribo" });
        tempMap.put("SST",
            new String[] { "Pacific/Pago_Pago", "Pacific/Midway" });
        tempMap.put("SVEMT", new String[] { "Asia/Yekaterinburg" });
        tempMap.put("SVEST", new String[] { "Asia/Yekaterinburg" });
        tempMap.put("SVET", new String[] { "Asia/Yekaterinburg" });
        tempMap.put("SWAT", new String[] { "Africa/Windhoek" });
        tempMap.put("SYOT", new String[] { "Antarctica/Syowa" });
        tempMap.put("TAHT", new String[] { "Pacific/Tahiti" });
        tempMap.put("TASST", new String[] { "Asia/Samarkand", "Asia/Tashkent" });
        tempMap.put("TAST", new String[] { "Asia/Samarkand", "Asia/Tashkent" });
        tempMap.put("TBIST", new String[] { "Asia/Tbilisi" });
        tempMap.put("TBIT", new String[] { "Asia/Tbilisi" });
        tempMap.put("TBMT", new String[] { "Asia/Tbilisi" });
        tempMap.put("TFT", new String[] { "Indian/Kerguelen" });
        tempMap.put("TJT", new String[] { "Asia/Dushanbe" });
        tempMap.put("TKT", new String[] { "Pacific/Fakaofo" });
        tempMap.put("TMST", new String[] { "Asia/Ashkhabad" });
        tempMap.put("TMT",
            new String[] { "Europe/Tallinn", "Asia/Tehran", "Asia/Ashkhabad" });
        tempMap.put("TOST", new String[] { "Pacific/Tongatapu" });
        tempMap.put("TOT", new String[] { "Pacific/Tongatapu" });
        tempMap.put("TPT", new String[] { "Asia/Dili" });
        tempMap.put("TRST", new String[] { "Europe/Istanbul" });
        tempMap.put("TRT", new String[] { "Europe/Istanbul" });
        tempMap.put("TRUT", new String[] { "Pacific/Truk" });
        tempMap.put("TVT", new String[] { "Pacific/Funafuti" });
        tempMap.put("ULAST", new String[] { "Asia/Ulaanbaatar" });
        tempMap.put("ULAT", new String[] { "Asia/Ulaanbaatar" });
        tempMap.put("URUT", new String[] { "Asia/Urumqi" });
        tempMap.put("UYHST", new String[] { "America/Montevideo" });
        tempMap.put("UYT", new String[] { "America/Montevideo" });
        tempMap.put("UZST", new String[] { "Asia/Samarkand", "Asia/Tashkent" });
        tempMap.put("UZT", new String[] { "Asia/Samarkand", "Asia/Tashkent" });
        tempMap.put("VET", new String[] { "America/Caracas" });
        tempMap.put("VLAMT", new String[] { "Asia/Vladivostok" });
        tempMap.put("VLAST", new String[] { "Asia/Vladivostok" });
        tempMap.put("VLAT", new String[] { "Asia/Vladivostok" });
        tempMap.put("VUST", new String[] { "Pacific/Efate" });
        tempMap.put("VUT", new String[] { "Pacific/Efate" });
        tempMap.put("WAKT", new String[] { "Pacific/Wake" });
        tempMap.put("WARST", new String[] { "America/Jujuy", "America/Mendoza" });
        tempMap.put("WART", new String[] { "America/Jujuy", "America/Mendoza" });
        tempMap.put("WAST",
            new String[] { "Africa/Ndjamena", "Africa/Windhoek" });
        tempMap.put("WAT",
            new String[] {
                "Africa/Luanda", "Africa/Porto-Novo", "Africa/Douala",
                "Africa/Bangui", "Africa/Ndjamena", "Africa/Kinshasa",
                "Africa/Brazzaville", "Africa/Malabo", "Africa/Libreville",
                "Africa/Banjul", "Africa/Conakry", "Africa/Bissau",
                "Africa/Bamako", "Africa/Nouakchott", "Africa/El_Aaiun",
                "Africa/Windhoek", "Africa/Niamey", "Africa/Lagos",
                "Africa/Dakar", "Africa/Freetown"
            });
        tempMap.put("WEST",
            new String[] {
                "Atlantic/Faeroe", "Atlantic/Azores", "Atlantic/Madeira",
                "Atlantic/Canary", "Europe/Brussels", "Europe/Luxembourg",
                "Europe/Monaco", "Europe/Lisbon", "Europe/Madrid",
                "Africa/Algiers", "Africa/Casablanca", "Africa/Ceuta"
            });
        tempMap.put("WET",
            new String[] {
                "Atlantic/Faeroe", "Atlantic/Azores", "Atlantic/Madeira",
                "Atlantic/Canary", "Europe/Andorra", "Europe/Brussels",
                "Europe/Luxembourg", "Europe/Monaco", "Europe/Lisbon",
                "Europe/Madrid", "Africa/Algiers", "Africa/Casablanca",
                "Africa/El_Aaiun", "Africa/Ceuta"
            });
        tempMap.put("WFT", new String[] { "Pacific/Wallis" });
        tempMap.put("WGST", new String[] { "America/Godthab" });
        tempMap.put("WGT", new String[] { "America/Godthab" });
        tempMap.put("WMT", new String[] { "Europe/Vilnius", "Europe/Warsaw" });
        tempMap.put("WST",
            new String[] { "Antarctica/Casey", "Pacific/Apia", "Australia/Perth" });
        tempMap.put("YAKMT", new String[] { "Asia/Yakutsk" });
        tempMap.put("YAKST", new String[] { "Asia/Yakutsk" });
        tempMap.put("YAKT", new String[] { "Asia/Yakutsk" });
        tempMap.put("YAPT", new String[] { "Pacific/Yap" });
        tempMap.put("YDDT",
            new String[] { "America/Whitehorse", "America/Dawson" });
        tempMap.put("YDT",
            new String[] {
                "America/Yakutat", "America/Whitehorse", "America/Dawson"
            });
        tempMap.put("YEKMT", new String[] { "Asia/Yekaterinburg" });
        tempMap.put("YEKST", new String[] { "Asia/Yekaterinburg" });
        tempMap.put("YEKT", new String[] { "Asia/Yekaterinburg" });
        tempMap.put("YERST", new String[] { "Asia/Yerevan" });
        tempMap.put("YERT", new String[] { "Asia/Yerevan" });
        tempMap.put("YST",
            new String[] {
                "America/Yakutat", "America/Whitehorse", "America/Dawson"
            });
        tempMap.put("YWT", new String[] { "America/Yakutat" });

        ABBREVIATED_TIMEZONES = Collections.unmodifiableMap(tempMap);
    }

    /**
     * Returns the 'official' Java timezone name for the given timezone
     *
     * @param timezoneStr the 'common' timezone name
     *
     * @return the Java timezone name for the given timezone
     */
    public static String getCanoncialTimezone(String timezoneStr) {
        if (timezoneStr == null) {
            return null;
        }

        timezoneStr = timezoneStr.trim();

        // Fix windows Daylight/Standard shift JDK doesn't map these (doh)
        String timezoneStrUC = timezoneStr.toUpperCase();
        int daylightIndex = timezoneStrUC.indexOf("DAYLIGHT");

        if (daylightIndex != -1) {
            StringBuffer timezoneBuf = new StringBuffer();
            timezoneBuf.append(timezoneStr.substring(0, daylightIndex));
            timezoneBuf.append("Standard");
            timezoneBuf.append(timezoneStr.substring(daylightIndex
                    + "DAYLIGHT".length(), timezoneStr.length()));
            timezoneStr = timezoneBuf.toString();
        }

        String canonicalTz = (String) TIMEZONE_MAPPINGS.get(timezoneStr);

        // if we didn't find it, try abbreviated timezones
        if (canonicalTz == null) {
            String[] abbreviatedTimezone = (String[]) ABBREVIATED_TIMEZONES.get(timezoneStr);

            if (abbreviatedTimezone != null) {
                // If there's only one mapping use that
                if (abbreviatedTimezone.length == 1) {
                    canonicalTz = abbreviatedTimezone[0];
                } else {
                    StringBuffer errorMsg = new StringBuffer(
                            "The server timezone value '");
                    errorMsg.append(timezoneStr);
                    errorMsg.append(
                        "' represents more than one timezone. You must ");
                    errorMsg.append(
                        "configure either the server or client to use a ");
                    errorMsg.append(
                        "more specifc timezone value if you want to enable ");
                    errorMsg.append("timezone support. The timezones that '");
                    errorMsg.append(timezoneStr);
                    errorMsg.append("maps to are: ");
                    errorMsg.append(abbreviatedTimezone[0]);

                    for (int i = 1; i < abbreviatedTimezone.length; i++) {
                        errorMsg.append(", ");
                        errorMsg.append(abbreviatedTimezone[i]);
                    }

                    throw new IllegalArgumentException(errorMsg.toString());
                }
            }
        }

        return canonicalTz;
    }

    /**
     * Change the given timestamp from one timezone to another
     *
     * @param conn the current connection to the MySQL server
     * @param tstamp the timestamp to change
     * @param fromTz the timezone to change from
     * @param toTz the timezone to change to
     *
     * @return the timestamp changed to the timezone 'toTz'
     */
    public static Timestamp changeTimezone(Connection conn, Timestamp tstamp,
        TimeZone fromTz, TimeZone toTz) {
        if ((conn != null) && conn.useTimezone()) {
            // Convert the timestamp from GMT to the server's timezone
            Calendar fromCal = Calendar.getInstance(fromTz);
            fromCal.setTime(tstamp);

            int fromOffset = fromCal.get(Calendar.ZONE_OFFSET)
                + fromCal.get(Calendar.DST_OFFSET);
            Calendar toCal = Calendar.getInstance(toTz);
            toCal.setTime(tstamp);

            int toOffset = toCal.get(Calendar.ZONE_OFFSET)
                + toCal.get(Calendar.DST_OFFSET);
            int offsetDiff = fromOffset - toOffset; //toOffset - fromOffset;
            long toTime = toCal.getTime().getTime();
            toTime += offsetDiff;

            Timestamp changedTimestamp = new Timestamp(toTime);

            return changedTimestamp;
        } else {
            return tstamp;
        }
    }

    /**
     * Change the given times from one timezone to another
     *
     * @param conn the current connection to the MySQL server
     * @param t the times to change
     * @param fromTz the timezone to change from
     * @param toTz the timezone to change to
     *
     * @return the times changed to the timezone 'toTz'
     */
    public static Time changeTimezone(Connection conn, Time t, TimeZone fromTz,
        TimeZone toTz) {
        if ((conn != null) && conn.useTimezone()) {
            // Convert the timestamp from GMT to the server's timezone
            Calendar fromCal = Calendar.getInstance(fromTz);
            fromCal.setTime(t);

            int fromOffset = fromCal.get(Calendar.ZONE_OFFSET)
                + fromCal.get(Calendar.DST_OFFSET);
            Calendar toCal = Calendar.getInstance(toTz);
            toCal.setTime(t);

            int toOffset = toCal.get(Calendar.ZONE_OFFSET)
                + toCal.get(Calendar.DST_OFFSET);
            int offsetDiff = toOffset - fromOffset;
            long toTime = toCal.getTime().getTime();
            toTime += offsetDiff;

            Time changedTime = new Time(toTime);

            return changedTime;
        } else {
            return t;
        }
    }
}
